Create KPI's Card 14

How to create KPI's

YOY KPI = [CY Death]/[LY Death]-1

Create Death Per Mth KPI

Death Per Mth = Death per Mth =

AVERAGEX(
VALUES( Fentayl_Drug_Related_Deaths[Date].[Month]),
[death #]
)

Create Total Death KPI

Total Death = Total Death by Fentayl = CALCULATE(COUNT(Fentayl_Drug_Related_Deaths[MannerofDeath])

,FILTER(Fentayl_Drug_Related_Deaths,Fentayl_Drug_Related_Deaths[MannerofDeath] = "Accident"))


KPIs are a great choice: